/**
 * 菜单表
 */

const seq = require('../seq')
const { STRING, TEXT, INTEGER } = require('../types')//sequelize的数据类型

const question = seq.define('question', {
    id: {
        type: INTEGER,
        primaryKey: true,
        allowNull: false,
        autoIncrement: true
    },
    openid:{
        type: STRING,
        comment: 'openid',
    },
    mobile: {
        type: STRING,
        comment: '手机号码'
    },
    resutl1:{
        type: STRING,
        comment: '问题结果1',
    },
    resutl2: {
        type: STRING,
        comment: '问题结果2',
    },
    resutl3: {
        type: STRING,
        comment: '问题结果3',
    },
    resutl4: {
        type: STRING,
        comment: '问题结果4',
    },
    area:{
        type: STRING,
        comment: '地区，上海和其他地区',
    },
    time1:{
        type: STRING,
        comment: '1',
    },
    time2: {
        type: STRING,
        comment: '2',
    },
    time3: {
        type: STRING,
        comment: '3',
    },
    time4: {
        type: STRING,
        comment: '4',
    },
    right1:{
        type: STRING,
        comment: '1正确，0错误',
    },
    right2: {
        type: STRING,
        comment: '1正确，0错误',
    },
    right3: {
        type: STRING,
        comment: '1正确，0错误',
    },
    right4: {
        type: STRING,
        comment: '1正确，0错误',
    },
    customerCode: {
        type: STRING,
        comment: '客户代码',
    }
})

module.exports = question

